SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
-- =============================================
-- Author:		<Author,,Name>
-- Create date: <Create Date, ,>
-- Description:	<Description, ,>
-- =============================================
CREATE FUNCTION [dbo].[GetPosName] 
(
	-- Add the parameters for the function here
	@PosId int
)
RETURNS nvarchar(10)
AS
BEGIN
	declare @ret nvarchar(10)

	Select @ret=Name 
	From dbo.Position
	Where dbo.Position.ID = @PosId
	
	return @ret;
END
GO
